package com.ts.proj.repository;


import com.ts.base.repository.CommonRepository;
import com.ts.proj.entity.SystemColumnEntity;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface SystemColumnRepository extends CommonRepository<SystemColumnEntity> {

    @Query(value=" SELECT t.TABLE_NAME FROM information_schema.TABLES t where t.TABLE_TYPE='BASE TABLE' and t.TABLE_SCHEMA='pem' and t.TABLE_NAME like 'ta_%' AND t.TABLE_NAME NOT LIKE '%sequence'  ",nativeQuery = true)
    List<String> findAllTables();

}
